﻿using System.Collections.Generic;
using Shrestha.Trigraph;
using System.Windows.Media;

namespace Shrestha.Database
{
    public interface DbManager
    {
        bool InitDb(string host, string database, string user, string password);
        List<TriEvent> GetTriEvents(string query);
        WorkingSet ExtractParameters(string tableName, string latName, string lngName, string timeName);
        WorkingSet ExtractParameters(string query);
        object ExecuteQuery(string queryText);
        bool CheckIfClustersExist();
        WorkingSet ExtractClusterParameters(int zoomlvl);

        WorkingSet ExtractParameters(string query, string cquery, bool isClustered);
        WorkingSet ExtractParameters(TriClusterEvent tce);
        
        List<string> GetTables();
        List<string> GetRows();
        Dictionary<string, Brush> GetGroupingEvent();

        WorkingSet ExtractParameters(string p, string p_2, string p_3, string p_4, string p_5);
    }
}
